<!DOCTYPE html>
<html>
<head data-suburl="">
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<meta http-equiv="X-UA-Compatible" content="IE=edge"/>
	
		<meta name="author" content="diogo" />
		<meta name="description" content="gnu-social - GNU social is a social communication software used in federated social networks. It is widely supported and has a large userbase. It is already used by the Free Software Foundation." />
		<meta name="keywords" content="go, git, self-hosted, gogs">
	
	<meta name="referrer" content="no-referrer" />
	<meta name="_csrf" content="-4lLDHeLkvcTbs-E155cylnSLKc6MTYwNDc5MjM3MjIzNjkxNTk2Ng==" />
	<meta name="_suburl" content="" />
	
	
	
		<meta property="og:url" content="https://notabug.org/diogo/gnu-social" />
		<meta property="og:type" content="object" />
		<meta property="og:title" content="diogo/gnu-social">
		<meta property="og:description" content="GNU social is a social communication software used in federated social networks. It is widely supported and has a large userbase. It is already used by the Free Software Foundation.">
		<meta property="og:image" content="https://notabug.org/avatars/12290" />
	

	<link rel="shortcut icon" href="/img/favicon.png" />

	<script src="/js/jquery-1.11.3.min.js"></script>
	<script src="/js/libs/jquery.are-you-sure.js"></script>
        <link href="/img/icon-48.ico" rel="icon" type="image/x-icon" />
        <link href="/img/icon-60.png" rel="apple-touch-icon">
        <link href="/img/icon-76.png" rel="apple-touch-icon" sizes="76x76">
        <link href="/img/icon-120.png" rel="apple-touch-icon" sizes="120x120">
        <link href="/img/icon-152.png" rel="apple-touch-icon" sizes="152x152">
        <link href="/img/icon-240.png" rel="apple-touch-icon" sizes="240x240">

	<link rel="stylesheet" href="/assets/font-awesome-4.6.3/css/font-awesome.min.css">
	<link rel="stylesheet" href="/assets/octicons-4.3.0/octicons.min.css">

	
	

	

	
	<link rel="stylesheet" href="/css/semantic-2.2.13.min.css">
	<link rel="stylesheet" href="/css/gogs.css?v=6fc9e85aa88133794d3434ea74aa557a">
	<link rel="stylesheet" href="/css/notabug.css">

	
	<script src="/js/semantic-2.2.13.min.js"></script>
	<script src="/js/gogs.js?v=6fc9e85aa88133794d3434ea74aa557a"></script>

	<title>Unknown error with checkschema.php - NotABug.org: Free code hosting</title>

	<meta name="theme-color" content="#428bca">

	


<noscript><style>.nojs-popup:hover > .menu { display: block ; }</style></noscript>


</head>
<body>
	<div class="full height">
		<noscript>Please enable JavaScript in your browser!</noscript>

		
			<div id="header-div" class="following bar light">
				<div class="ui container">
					<div class="ui grid">
						<div class="column">
							<div class="ui top secondary menu">
								<a class="item brand" href="/">
									<img class="ui mini image" src="/img/favicon.png">
								</a>

								
									<a class="item" href="/">Home</a>
								

								<a class="item" href="/explore/repos">Explore</a>
								

								



									<a class="notabug-item item" href="/help" rel="noreferrer">Help</a>




									<div class="right menu">
										
											<a class="item" href="/user/sign_up">
												<i class="octicon octicon-person"></i> Register
											</a>
										
										<a class="item" href="/user/login?redirect_to=%2fdiogo%2fgnu-social%2fissues%2f205">
											<i class="octicon octicon-sign-in"></i> Sign In
										</a>
									</div>

								
							</div>
						</div>
					</div>
				</div>
			</div>
		


<div class="repository view issue pull">
	<div class="header-wrapper">

	<div class="ui container">
		<div class="ui vertically padded grid head">
			<div class="column">
				<div class="ui header">
					<div class="ui huge breadcrumb">
						<i class="mega-octicon octicon-repo"></i>
						<a href="/diogo">diogo</a>
						<div class="divider"> / </div>
						<a href="/diogo/gnu-social">gnu-social</a>
						
						
					</div>

					
						<div class="ui right">
							<div class="ui labeled button" tabindex="0">
								<a class="ui basic button" href="/diogo/gnu-social/action/watch?redirect_to=%2fdiogo%2fgnu-social%2fissues%2f205">
									<i class="icon fa-eye-slash"></i>Watch
								</a>
								<a class="ui basic label" href="/diogo/gnu-social/watchers">
									9
								</a>
							</div>
							<div class="ui labeled button" tabindex="0">
								<a class="ui basic button" href="/diogo/gnu-social/action/star?redirect_to=%2fdiogo%2fgnu-social%2fissues%2f205">
									<i class="icon fa-star-o"></i>Star
								</a>
								<a class="ui basic label" href="/diogo/gnu-social/stars">
									22
								</a>
							</div>
							
								<div class="ui labeled button" tabindex="0">
									<a class="ui basic button " href="/repo/fork/25974">
										<i class="octicon octicon-repo-forked"></i>Fork
									</a>
									<a class="ui basic label" href="/diogo/gnu-social/forks">
										21
									</a>
								</div>
							
						</div>
					
				</div>
			</div>
		</div>
	</div>


	<div class="ui tabs container">
		<div class="ui tabular menu navbar">
			
				<a class=" item" href="/diogo/gnu-social">
					<i class="octicon octicon-file-text"></i> Files
				</a>
			
			
				<a class="active item" href="/diogo/gnu-social/issues">
					<i class="octicon octicon-issue-opened"></i> Issues <span class="ui blue small label">73</span>
				</a>
			
			
				<a class=" item" href="/diogo/gnu-social/pulls">
					<i class="octicon octicon-git-pull-request"></i> Pull Requests <span class="ui blue small label">3</span>
				</a>
			
			
				<a class=" item" href="/diogo/gnu-social/wiki">
					<i class="octicon octicon-book"></i> Wiki
				</a>
			
			
		</div>
	</div>
	<div class="ui tabs divider"></div>

</div>

	<div class="ui container">
		<div class="navbar">
			<div class="ui compact small menu">
	<a class=" item" href="/diogo/gnu-social/labels">Labels</a>
	<a class=" item" href="/diogo/gnu-social/milestones">Milestones</a>
</div>

			<div class="ui right">
				
					<a class="ui green button" href="/diogo/gnu-social/issues/new">New Issue</a>
				
			</div>
		</div>
		<div class="ui divider"></div>
		
			<div>
				<div class="ui grid">
	
	
		<div class="sixteen wide column title">
	<div class="ui grid">
		<h1 class="twelve wide column">
			<span class="index">#205</span> <span id="issue-title" class="has-emoji">Unknown error with checkschema.php</span>
			<div id="edit-title-input" class="ui input" style="display: none">
				<input value="Unknown error with checkschema.php">
			</div>
		</h1>
		
	</div>
	
		<div class="ui red large label"><i class="octicon octicon-issue-closed"></i> Closed</div>
	

	
		
		<span class="time-desc">
			
				opened <span class="time-since" title="Fri, 28 Aug 2020 07:53:21 UTC">2 months ago</span> by <a href="/postblue">postblue</a>
			
			·
			8 comments
		</span>
	
	<div class="ui divider"></div>
</div>

	

	
	<div class="twelve wide column comment-list">
		<ui class="ui comments">
			<div class="comment">
				<a class="avatar" href="/postblue">
					<img src="/avatars/69">
				</a>
				<div class="content">
					<div class="ui top attached header">
						<span class="text grey"><a href="/postblue">Guillaume</a> commented <a href="#issue-65557"><span class="time-since" title="Fri, 28 Aug 2020 07:53:21 UTC">2 months ago</span></a></span>
						<div class="ui right actions">
							
						</div>
					</div>
					<div class="ui attached segment">
						<div class="render-content markdown has-emoji">
							
								<pre><code>Constraint checking Notice table...
* notice_reply_to_fkey (reply_to =&gt; notice.id)
* notice_repeat_of_fkey (repeat_of =&gt; notice.id)
* notice_profile_id_fkey (profile_id =&gt; profile.id)
PHP Fatal error:  Uncaught PEAR_Exception: DB Error: unknown error in /var/www/social/lib/database/schema.php on line 544
#0 /var/www/social/lib/database/schema.php(544): PEAR_ErrorToPEAR_Exception(Object(DB_Error))
#1 /var/www/social/lib/database/schema.php(519): Schema-&gt;runSqlSet(Array)
#2 /var/www/social/lib/database/schemaupdater.php(70): Schema-&gt;ensureTable(&#39;notice&#39;, Array)
#3 /var/www/social/scripts/checkschema.php(50): SchemaUpdater-&gt;checkSchema()
#4 {main}
  thrown in /var/www/social/lib/util/framework.php on line 216
</code></pre>

							
						</div>
						<div class="raw-content hide">```
Constraint checking Notice table...
* notice_reply_to_fkey (reply_to =&gt; notice.id)
* notice_repeat_of_fkey (repeat_of =&gt; notice.id)
* notice_profile_id_fkey (profile_id =&gt; profile.id)
PHP Fatal error:  Uncaught PEAR_Exception: DB Error: unknown error in /var/www/social/lib/database/schema.php on line 544
#0 /var/www/social/lib/database/schema.php(544): PEAR_ErrorToPEAR_Exception(Object(DB_Error))
#1 /var/www/social/lib/database/schema.php(519): Schema-&gt;runSqlSet(Array)
#2 /var/www/social/lib/database/schemaupdater.php(70): Schema-&gt;ensureTable(&#39;notice&#39;, Array)
#3 /var/www/social/scripts/checkschema.php(50): SchemaUpdater-&gt;checkSchema()
#4 {main}
  thrown in /var/www/social/lib/util/framework.php on line 216
```</div>
						<div class="edit-content-zone hide" data-write="issue-65557-write" data-preview="issue-65557-preview" data-update-url="/diogo/gnu-social/issues/205/content" data-context="/diogo/gnu-social"></div>
					</div>
					
				</div>
			</div>

			
				

				
				
					<div class="comment" id="issuecomment-20902">
						<a class="avatar" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/XRevan86">XRevan86</a> commented <a href="#issuecomment-20902"><span class="time-since" title="Sun, 30 Aug 2020 23:09:57 UTC">2 months ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Collaborator
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p>If on PostgreSQL, look into <code>/var/log/postgresql/</code>, it records the failing queries.</p>

<p>If on MariaDB, enable <a href="https://mariadb.com/kb/en/sql-error-log-plugin/" rel="nofollow">sql_errlog</a>, something like this:</p>

<pre><code class="language-toml">plugin_load_add         = sql_errlog
sql_error_log           = FORCE
sql_error_log_filename  = /var/log/mysql/sqlerr.log
sql_error_log_rotate    = ON
</code></pre>

<p>Then that file will contain the query that makes this fail.</p>

<p>Sorry for having to resort to this…</p>

									
								</div>
								<div class="raw-content hide">If on PostgreSQL, look into ```/var/log/postgresql/```, it records the failing queries.

If on MariaDB, enable [sql_errlog](https://mariadb.com/kb/en/sql-error-log-plugin/), something like this:
```toml
plugin_load_add         = sql_errlog
sql_error_log           = FORCE
sql_error_log_filename  = /var/log/mysql/sqlerr.log
sql_error_log_rotate    = ON
```
Then that file will contain the query that makes this fail.

Sorry for having to resort to this…</div>
								<div class="edit-content-zone hide" data-write="issuecomment-20902-write" data-preview="issuecomment-20902-preview" data-update-url="/diogo/gnu-social/comments/20902" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-20904">
						<a class="avatar" href="/postblue">
							<img src="/avatars/69">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/postblue">Guillaume</a> commented <a href="#issuecomment-20904"><span class="time-since" title="Mon, 31 Aug 2020 06:02:56 UTC">2 months ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Poster
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p>Ok, since latest update it&#39;s working, I don&#39;t know why and I don&#39;t like not knowing why. Maybe is it related to the utf8 settings I had to enforce in MariaDB because encoding was all over the place?</p>

<pre><code>[client]
default-character-set = utf8mb4

[mysqld]
character-set-server  = utf8mb4
collation-server      = utf8mb4_unicode_ci
init-connect=&#39;SET NAMES utf8mb4&#39;
</code></pre>

<p>Besides, I&#39;m still seeing notices with whacked up encoding, like <a href="https://herds.eu/conversation/3292547#notice-5470203" rel="nofollow">https://herds.eu/conversation/3292547#notice-5470203</a>, is there a script to fix it?</p>

<p>Update:</p>

<p>I ran a little script to change collation in the database/tables:</p>

<pre><code>#!/bin/bash

# mycollate.sh &lt;database&gt; [&lt;charset&gt; &lt;collation&gt;]
# changes MySQL/MariaDB charset and collation for one database - all tables and
# all columns in all tables

DB=&#34;$1&#34;
CHARSET=&#34;$2&#34;
COLL=&#34;$3&#34;

[ -n &#34;$DB&#34; ] || exit 1
[ -n &#34;$CHARSET&#34; ] || CHARSET=&#34;utf8mb4&#34;
[ -n &#34;$COLL&#34; ] || COLL=&#34;utf8mb4_general_ci&#34;

echo $DB
echo &#34;ALTER DATABASE \`$DB\` CHARACTER SET $CHARSET COLLATE $COLL;&#34; | mysql

echo &#34;USE \`$DB\`; SHOW TABLES;&#34; | mysql -s | (
    while read TABLE; do
        echo $DB.$TABLE
        echo &#34;ALTER TABLE \`$TABLE\` CONVERT TO CHARACTER SET $CHARSET COLLATE $COLL;&#34; | mysql $DB
    done
)
</code></pre>

<p>Mostly it&#39;s working but I&#39;m getting a few errors in the sqlerr.log file I created earlier (mainly duplicate entries):</p>

<pre><code>2020-08-31  8:29:49 root[root] @ localhost [] ERROR 1114: The table &#39;notice&#39; is full : ALTER TABLE `notice` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
[...]
2020-08-31  8:30:06 root[root] @ localhost [] ERROR 1062: Duplicate entry &#39;livetweeter&#39; for key &#39;PRIMARY&#39; : ALTER TABLE `notice_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
2020-08-31  8:30:21 root[root] @ localhost [] ERROR 1062: Duplicate entry &#39;yaséquenoaplauden-109690&#39; for key &#39;PRIMARY&#39; : ALTER TABLE `notice_tag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
2020-08-31  8:30:27 root[root] @ localhost [] ERROR 1062: Duplicate entry &#39;https://7nw.eu/users/luclu7&#39; for key &#39;PRIMARY&#39; : ALTER TABLE `ostatus_profile` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
</code></pre>

<p>The intriguing one is <code>The table &#39;notice&#39; is full</code> and I don&#39;t find any documentation on that one.</p>

									
								</div>
								<div class="raw-content hide">Ok, since latest update it&#39;s working, I don&#39;t know why and I don&#39;t like not knowing why. Maybe is it related to the utf8 settings I had to enforce in MariaDB because encoding was all over the place?

```
[client]
default-character-set = utf8mb4

[mysqld]
character-set-server  = utf8mb4
collation-server      = utf8mb4_unicode_ci
init-connect=&#39;SET NAMES utf8mb4&#39;
```

Besides, I&#39;m still seeing notices with whacked up encoding, like https://herds.eu/conversation/3292547#notice-5470203, is there a script to fix it?

Update:

I ran a little script to change collation in the database/tables:

```
#!/bin/bash

# mycollate.sh &lt;database&gt; [&lt;charset&gt; &lt;collation&gt;]
# changes MySQL/MariaDB charset and collation for one database - all tables and
# all columns in all tables

DB=&#34;$1&#34;
CHARSET=&#34;$2&#34;
COLL=&#34;$3&#34;

[ -n &#34;$DB&#34; ] || exit 1
[ -n &#34;$CHARSET&#34; ] || CHARSET=&#34;utf8mb4&#34;
[ -n &#34;$COLL&#34; ] || COLL=&#34;utf8mb4_general_ci&#34;

echo $DB
echo &#34;ALTER DATABASE \`$DB\` CHARACTER SET $CHARSET COLLATE $COLL;&#34; | mysql

echo &#34;USE \`$DB\`; SHOW TABLES;&#34; | mysql -s | (
    while read TABLE; do
        echo $DB.$TABLE
        echo &#34;ALTER TABLE \`$TABLE\` CONVERT TO CHARACTER SET $CHARSET COLLATE $COLL;&#34; | mysql $DB
    done
)
```

Mostly it&#39;s working but I&#39;m getting a few errors in the sqlerr.log file I created earlier (mainly duplicate entries):

```
2020-08-31  8:29:49 root[root] @ localhost [] ERROR 1114: The table &#39;notice&#39; is full : ALTER TABLE `notice` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
[...]
2020-08-31  8:30:06 root[root] @ localhost [] ERROR 1062: Duplicate entry &#39;livetweeter&#39; for key &#39;PRIMARY&#39; : ALTER TABLE `notice_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
2020-08-31  8:30:21 root[root] @ localhost [] ERROR 1062: Duplicate entry &#39;yaséquenoaplauden-109690&#39; for key &#39;PRIMARY&#39; : ALTER TABLE `notice_tag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
2020-08-31  8:30:27 root[root] @ localhost [] ERROR 1062: Duplicate entry &#39;https://7nw.eu/users/luclu7&#39; for key &#39;PRIMARY&#39; : ALTER TABLE `ostatus_profile` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
```

The intriguing one is `The table &#39;notice&#39; is full` and I don&#39;t find any documentation on that one.</div>
								<div class="edit-content-zone hide" data-write="issuecomment-20904-write" data-preview="issuecomment-20904-preview" data-update-url="/diogo/gnu-social/comments/20904" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-20967">
						<a class="avatar" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/XRevan86">XRevan86</a> commented <a href="#issuecomment-20967"><span class="time-since" title="Mon, 07 Sep 2020 19:52:11 UTC">2 months ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Collaborator
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<blockquote>
<p>The intriguing one is <code>The table &#39;notice&#39; is full</code> and I don&#39;t find any documentation on that one.</p>
</blockquote>

<p>Indeed, not sure what that means. But don&#39;t use that script, use <code>checkschema.php</code> instead.</p>

<blockquote>
<p>I had to enforce in MariaDB because encoding was all over the place</p>
</blockquote>

<p>Guillaume, that can&#39;t be right, GNU social creates everything with <code>utf8mb4</code> on its own: <a href="https://notabug.org/diogo/gnu-social/src/be5bec98879db6724bc596e2581ce0400d71c193/lib/database/mysqlschema.php#L366" rel="nofollow">lib/database/mysqlschema.php#L366</a></p>

<blockquote>
<p>is there a script to fix it?</p>
</blockquote>

<p>That should not have happened in the first place…</p>

									
								</div>
								<div class="raw-content hide">&gt; The intriguing one is ```The table &#39;notice&#39; is full``` and I don&#39;t find any documentation on that one.

Indeed, not sure what that means. But don&#39;t use that script, use ```checkschema.php``` instead.  
&gt; I had to enforce in MariaDB because encoding was all over the place

Guillaume, that can&#39;t be right, GNU social creates everything with ```utf8mb4``` on its own: [lib/database/mysqlschema.php#L366](https://notabug.org/diogo/gnu-social/src/be5bec98879db6724bc596e2581ce0400d71c193/lib/database/mysqlschema.php#L366)  
&gt; is there a script to fix it?

That should not have happened in the first place…</div>
								<div class="edit-content-zone hide" data-write="issuecomment-20967-write" data-preview="issuecomment-20967-preview" data-update-url="/diogo/gnu-social/comments/20967" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-21057">
						<a class="avatar" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/XRevan86">XRevan86</a> commented <a href="#issuecomment-21057"><span class="time-since" title="Mon, 14 Sep 2020 17:50:10 UTC">1 month ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Collaborator
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p>If this is caused by <a href="/diogo/gnu-social/commit/b01974b665e7e733385589901343adc739952e25" rel="nofollow"><code>b01974b665</code></a>, then <a href="/diogo/gnu-social/commit/b04469a252c8b31e17dd5099598ed47b61b97ad7" rel="nofollow"><code>b04469a252</code></a> should fix this.</p>

									
								</div>
								<div class="raw-content hide">If this is caused by b01974b665e7e733385589901343adc739952e25, then b04469a252c8b31e17dd5099598ed47b61b97ad7 should fix this.</div>
								<div class="edit-content-zone hide" data-write="issuecomment-21057-write" data-preview="issuecomment-21057-preview" data-update-url="/diogo/gnu-social/comments/21057" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="event">
						<span class="octicon octicon-circle-slash"></span>
						<a class="ui avatar image" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<span class="text grey"><a href="/XRevan86">XRevan86</a> closed <a id="event-21170" href="#event-21170"><span class="time-since" title="Wed, 23 Sep 2020 15:06:38 UTC">1 month ago</span></a></span>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-21185">
						<a class="avatar" href="/postblue">
							<img src="/avatars/69">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/postblue">Guillaume</a> commented <a href="#issuecomment-21185"><span class="time-since" title="Thu, 24 Sep 2020 17:58:04 UTC">1 month ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Poster
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p>Running upgrade.php, still getting the first issue</p>

<pre><code>udo -u www-data php scripts/upgrade.php -f
[sudo] Mot de passe de postblue : 
Ensuring all conversations have a URI...DONE.
Upgrading core schema...
Constraint checking Notice table...
* notice_reply_to_fkey (reply_to =&gt; notice.id)
* notice_repeat_of_fkey (repeat_of =&gt; notice.id)
* notice_profile_id_fkey (profile_id =&gt; profile.id)
PHP Fatal error:  Uncaught PEAR_Exception: DB Error: unknown error in /var/www/social/lib/database/schema.php on line 544                                                                                                                     
#0 /var/www/social/lib/database/schema.php(544): PEAR_ErrorToPEAR_Exception(Object(DB_Error))
#1 /var/www/social/lib/database/schema.php(519): Schema-&gt;runSqlSet(Array)
#2 /var/www/social/lib/database/schemaupdater.php(70): Schema-&gt;ensureTable(&#39;notice&#39;, Array)
#3 /var/www/social/scripts/upgrade.php(109): SchemaUpdater-&gt;checkSchema()
#4 /var/www/social/scripts/upgrade.php(58): updateSchemaCore()
#5 /var/www/social/scripts/upgrade.php(714): main()
#6 {main}
  thrown in /var/www/social/lib/util/framework.php on line 216
</code></pre>

<p>With this error:</p>

<pre><code>2020-09-24 19:21:25 social[social] @ localhost [] ERROR 1114: The table &#39;notice&#39; is full : ALTER TABLE `notice` DROP INDEX notice_url_idx, MODIFY COLUMN `content` text COLLATE utf8mb4_unicode_ci NULL COMMENT &#39;update content&#39;,
MODIFY COLUMN `url` text COLLATE utf8mb4_bin NULL COMMENT &#39;URL of any attachment (image, video, bookmark, whatever)&#39;, ADD INDEX notice_url_idx (`url`(191))
</code></pre>

<p>I may be running out of disk space over the time (90% of 40Go), is there a good way to &#34;clean&#34; an installation/database of unneeded files/references/... after 5+ years?</p>

<p>Checking disk usage, I have: 5,6G of /file/avatars, 2,3G of /file/thumbs, 8,1G of files in /file.</p>

									
								</div>
								<div class="raw-content hide">Running upgrade.php, still getting the first issue

```
udo -u www-data php scripts/upgrade.php -f
[sudo] Mot de passe de postblue : 
Ensuring all conversations have a URI...DONE.
Upgrading core schema...
Constraint checking Notice table...
* notice_reply_to_fkey (reply_to =&gt; notice.id)
* notice_repeat_of_fkey (repeat_of =&gt; notice.id)
* notice_profile_id_fkey (profile_id =&gt; profile.id)
PHP Fatal error:  Uncaught PEAR_Exception: DB Error: unknown error in /var/www/social/lib/database/schema.php on line 544                                                                                                                     
#0 /var/www/social/lib/database/schema.php(544): PEAR_ErrorToPEAR_Exception(Object(DB_Error))
#1 /var/www/social/lib/database/schema.php(519): Schema-&gt;runSqlSet(Array)
#2 /var/www/social/lib/database/schemaupdater.php(70): Schema-&gt;ensureTable(&#39;notice&#39;, Array)
#3 /var/www/social/scripts/upgrade.php(109): SchemaUpdater-&gt;checkSchema()
#4 /var/www/social/scripts/upgrade.php(58): updateSchemaCore()
#5 /var/www/social/scripts/upgrade.php(714): main()
#6 {main}
  thrown in /var/www/social/lib/util/framework.php on line 216
```

With this error:

```
2020-09-24 19:21:25 social[social] @ localhost [] ERROR 1114: The table &#39;notice&#39; is full : ALTER TABLE `notice` DROP INDEX notice_url_idx, MODIFY COLUMN `content` text COLLATE utf8mb4_unicode_ci NULL COMMENT &#39;update content&#39;,
MODIFY COLUMN `url` text COLLATE utf8mb4_bin NULL COMMENT &#39;URL of any attachment (image, video, bookmark, whatever)&#39;, ADD INDEX notice_url_idx (`url`(191))
```

I may be running out of disk space over the time (90% of 40Go), is there a good way to &#34;clean&#34; an installation/database of unneeded files/references/... after 5&#43; years?

Checking disk usage, I have: 5,6G of /file/avatars, 2,3G of /file/thumbs, 8,1G of files in /file.</div>
								<div class="edit-content-zone hide" data-write="issuecomment-21185-write" data-preview="issuecomment-21185-preview" data-update-url="/diogo/gnu-social/comments/21185" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-21188">
						<a class="avatar" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/XRevan86">XRevan86</a> commented <a href="#issuecomment-21188"><span class="time-since" title="Thu, 24 Sep 2020 19:44:16 UTC">1 month ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Collaborator
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p>This is very suspicious still, I wonder if it&#39;s all in <code>/var/lib/mysql/ibdata1</code> and not in individual InnoDB tablespaces.<br>
Though a more probable cause is that this needs a relation rebuild, and there&#39;s indeed no space for that.</p>

									
								</div>
								<div class="raw-content hide">This is very suspicious still, I wonder if it&#39;s all in ```/var/lib/mysql/ibdata1``` and not in individual InnoDB tablespaces.  
Though a more probable cause is that this needs a relation rebuild, and there&#39;s indeed no space for that.</div>
								<div class="edit-content-zone hide" data-write="issuecomment-21188-write" data-preview="issuecomment-21188-preview" data-update-url="/diogo/gnu-social/comments/21188" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-21432">
						<a class="avatar" href="/postblue">
							<img src="/avatars/69">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/postblue">Guillaume</a> commented <a href="#issuecomment-21432"><span class="time-since" title="Sun, 11 Oct 2020 13:47:20 UTC">3 weeks ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Poster
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p>Still getting this error:</p>

<pre><code>PHP Fatal error:  Uncaught PEAR_Exception: MDB2 Error: unknown error in /var/www/social/lib/database/schema.php on line 569
#0 /var/www/social/lib/database/schema.php(569): PEAR_ErrorToPEAR_Exception(Object(MDB2_Error))
#1 /var/www/social/lib/database/schema.php(541): Schema-&gt;runSqlSet(Array)
#2 /var/www/social/lib/database/schemaupdater.php(70): Schema-&gt;ensureTable(&#39;user&#39;, Array)
#3 /var/www/social/scripts/upgrade.php(109): SchemaUpdater-&gt;checkSchema()
#4 /var/www/social/scripts/upgrade.php(58): updateSchemaCore()
#5 /var/www/social/scripts/upgrade.php(714): main()
#6 {main}
  thrown in /var/www/social/lib/util/framework.php on line 215
</code></pre>

<p>Getting this in sqlerr.log:</p>

<pre><code>MODIFY COLUMN `uri` varchar(191) COLLATE &#39;utf82020-10-11 15:46:12 social[social] @ localhost [] ERROR 1115: Unknown character set: &#39;utf8mb4 COLLATE &#39; : ALTER TABLE `user` DROP INDEX user_created_idx, MODIFY COLUMN `nickname` varchar(64) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;nickname or username, duped in profile&#39;,
MODIFY COLUMN `password` text COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;salted password, can be null for OpenID users&#39;,
MODIFY COLUMN `email` varchar(191) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;email address for password recovery etc.&#39;,
MODIFY COLUMN `incomingemail` varchar(191) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;email address for post-by-email&#39;,
MODIFY COLUMN `language` varchar(50) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;preferred language&#39;,
MODIFY COLUMN `timezone` varchar(50) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;timezone&#39;,
MODIFY COLUMN `sms` varchar(64) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;sms phone number&#39;,
MODIFY COLUMN `smsemail` varchar(191) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;built from sms and carrier&#39;,
MODIFY COLUMN `uri` varchar(191) COLLATE &#39;utf8
</code></pre>

<p>Disk of 38G, 29G used, 7,3G free.</p>

									
								</div>
								<div class="raw-content hide">Still getting this error:

```
PHP Fatal error:  Uncaught PEAR_Exception: MDB2 Error: unknown error in /var/www/social/lib/database/schema.php on line 569
#0 /var/www/social/lib/database/schema.php(569): PEAR_ErrorToPEAR_Exception(Object(MDB2_Error))
#1 /var/www/social/lib/database/schema.php(541): Schema-&gt;runSqlSet(Array)
#2 /var/www/social/lib/database/schemaupdater.php(70): Schema-&gt;ensureTable(&#39;user&#39;, Array)
#3 /var/www/social/scripts/upgrade.php(109): SchemaUpdater-&gt;checkSchema()
#4 /var/www/social/scripts/upgrade.php(58): updateSchemaCore()
#5 /var/www/social/scripts/upgrade.php(714): main()
#6 {main}
  thrown in /var/www/social/lib/util/framework.php on line 215
```

Getting this in sqlerr.log:

```
MODIFY COLUMN `uri` varchar(191) COLLATE &#39;utf82020-10-11 15:46:12 social[social] @ localhost [] ERROR 1115: Unknown character set: &#39;utf8mb4 COLLATE &#39; : ALTER TABLE `user` DROP INDEX user_created_idx, MODIFY COLUMN `nickname` varchar(64) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;nickname or username, duped in profile&#39;,
MODIFY COLUMN `password` text COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;salted password, can be null for OpenID users&#39;,
MODIFY COLUMN `email` varchar(191) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;email address for password recovery etc.&#39;,
MODIFY COLUMN `incomingemail` varchar(191) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;email address for post-by-email&#39;,
MODIFY COLUMN `language` varchar(50) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;preferred language&#39;,
MODIFY COLUMN `timezone` varchar(50) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;timezone&#39;,
MODIFY COLUMN `sms` varchar(64) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;sms phone number&#39;,
MODIFY COLUMN `smsemail` varchar(191) COLLATE &#39;utf8mb4_bin&#39; NULL COMMENT &#39;built from sms and carrier&#39;,
MODIFY COLUMN `uri` varchar(191) COLLATE &#39;utf8
```

Disk of 38G, 29G used, 7,3G free.</div>
								<div class="edit-content-zone hide" data-write="issuecomment-21432-write" data-preview="issuecomment-21432-preview" data-update-url="/diogo/gnu-social/comments/21432" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="event">
						<span class="octicon octicon-primitive-dot"></span>
						<a class="ui avatar image" href="/postblue">
							<img src="/avatars/69">
						</a>
						<span class="text grey"><a href="/postblue">postblue</a> reopened <a id="event-21433" href="#event-21433"><span class="time-since" title="Sun, 11 Oct 2020 13:47:23 UTC">3 weeks ago</span></a></span>
					</div>
				

			
				

				
				
					<div class="comment" id="issuecomment-21467">
						<a class="avatar" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/XRevan86">XRevan86</a> commented <a href="#issuecomment-21467"><span class="time-since" title="Tue, 13 Oct 2020 00:38:20 UTC">3 weeks ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Collaborator
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<p><a href="/postblue" rel="nofollow">@postblue</a>, that was a new issue caused by my typo, fixed in <a href="/diogo/gnu-social/commit/06dfd91a82dae81fb500eaed5112d4753b951dab" rel="nofollow"><code>06dfd91a82</code></a>.</p>

									
								</div>
								<div class="raw-content hide">@postblue, that was a new issue caused by my typo, fixed in 06dfd91a82dae81fb500eaed5112d4753b951dab.</div>
								<div class="edit-content-zone hide" data-write="issuecomment-21467-write" data-preview="issuecomment-21467-preview" data-update-url="/diogo/gnu-social/comments/21467" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			
				

				
				
					<div class="event">
						<span class="octicon octicon-circle-slash"></span>
						<a class="ui avatar image" href="/XRevan86">
							<img src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332">
						</a>
						<span class="text grey"><a href="/XRevan86">XRevan86</a> closed <a id="event-21468" href="#event-21468"><span class="time-since" title="Tue, 13 Oct 2020 00:38:20 UTC">3 weeks ago</span></a></span>
					</div>
				

			

			

			
				<div class="ui warning message">
					<a href="/user/login?redirect_to=/diogo/gnu-social/issues/205">Sign in</a> to join this conversation.
				</div>
			
		</ui>
	</div>

	<div class="four wide column">
		<div class="ui segment metas">
			<div class="ui disabled floating jump select-label dropdown">
				<span class="text">
					<strong>Labels</strong>
					<span class="octicon octicon-gear"></span>
				</span>
				<div class="filter menu" data-action="update" data-update-url="/diogo/gnu-social/issues/205/label">
					<div class="no-select item">Clear labels</div>
					
						<a class=" item" href="#" data-id="1564" data-id-selector="#label_1564"><span class="octicon "></span><span class="label color" style="background-color: #fbca04"></span> bounty</a>
					
						<a class=" item" href="#" data-id="1483" data-id-selector="#label_1483"><span class="octicon "></span><span class="label color" style="background-color: #ee0701"></span> bug</a>
					
						<a class=" item" href="#" data-id="1484" data-id-selector="#label_1484"><span class="octicon "></span><span class="label color" style="background-color: #cccccc"></span> duplicate</a>
					
						<a class=" item" href="#" data-id="1485" data-id-selector="#label_1485"><span class="octicon "></span><span class="label color" style="background-color: #84b6eb"></span> enhancement</a>
					
						<a class=" item" href="#" data-id="1486" data-id-selector="#label_1486"><span class="octicon "></span><span class="label color" style="background-color: #128a0c"></span> help wanted</a>
					
						<a class=" item" href="#" data-id="1487" data-id-selector="#label_1487"><span class="octicon "></span><span class="label color" style="background-color: #e6e6e6"></span> invalid</a>
					
						<a class=" item" href="#" data-id="1488" data-id-selector="#label_1488"><span class="octicon "></span><span class="label color" style="background-color: #cc317c"></span> question</a>
					
						<a class=" item" href="#" data-id="1565" data-id-selector="#label_1565"><span class="octicon "></span><span class="label color" style="background-color: #d4c5f9"></span> RFC</a>
					
						<a class=" item" href="#" data-id="1841" data-id-selector="#label_1841"><span class="octicon "></span><span class="label color" style="background-color: #0052cc"></span> v3</a>
					
						<a class=" item" href="#" data-id="1489" data-id-selector="#label_1489"><span class="octicon "></span><span class="label color" style="background-color: #ffffff"></span> wontfix</a>
					
				</div>
			</div>
			<div class="ui labels list">
				<span class="no-select item ">No Label</span>
				
					<div class="item">
						<a class="ui label hide" id="label_1564" href="/diogo/gnu-social/issues?labels=1564" style="color: #000; background-color: #fbca04">bounty</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1483" href="/diogo/gnu-social/issues?labels=1483" style="color: #fff; background-color: #ee0701">bug</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1484" href="/diogo/gnu-social/issues?labels=1484" style="color: #000; background-color: #cccccc">duplicate</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1485" href="/diogo/gnu-social/issues?labels=1485" style="color: #000; background-color: #84b6eb">enhancement</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1486" href="/diogo/gnu-social/issues?labels=1486" style="color: #fff; background-color: #128a0c">help wanted</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1487" href="/diogo/gnu-social/issues?labels=1487" style="color: #000; background-color: #e6e6e6">invalid</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1488" href="/diogo/gnu-social/issues?labels=1488" style="color: #fff; background-color: #cc317c">question</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1565" href="/diogo/gnu-social/issues?labels=1565" style="color: #000; background-color: #d4c5f9">RFC</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1841" href="/diogo/gnu-social/issues?labels=1841" style="color: #fff; background-color: #0052cc">v3</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1489" href="/diogo/gnu-social/issues?labels=1489" style="color: #000; background-color: #ffffff">wontfix</a>
					</div>

				
			</div>

			<div class="ui divider"></div>

			<div class="ui disabled floating jump select-milestone dropdown">
				<span class="text">
					<strong>Milestone</strong>
					<span class="octicon octicon-gear"></span>
				</span>
				<div class="menu" data-action="update" data-update-url="/diogo/gnu-social/issues/205/milestone">
					<div class="no-select item">Clear milestone</div>
					
					
				</div>
			</div>
			<div class="ui select-milestone list">
				<span class="no-select item ">No Milestone</span>
				<div class="selected">
					
				</div>
			</div>

			<div class="ui divider"></div>

			<input id="assignee_id" name="assignee_id" type="hidden" value="">
			<div class="ui disabled floating jump select-assignee dropdown">
				<span class="text">
					<strong>Assignee</strong>
					<span class="octicon octicon-gear"></span>
				</span>
				<div class="menu" data-action="update" data-update-url="/diogo/gnu-social/issues/205/assignee">
					<div class="no-select item">Clear assignee</div>
					
				</div>
			</div>
			<div class="ui select-assignee list">
				<span class="no-select item ">No assignee</span>
				<div class="selected">
					
				</div>
			</div>

			<div class="ui divider"></div>

			<div class="ui participants">
				<span class="text"><strong>2 Participants</strong></span>
				<div>
					
						<a href="/postblue">
							<img class="ui avatar image poping up" src="/avatars/69" data-content="Guillaume" data-position="top center" data-variation="small inverted">
						</a>
					
						<a href="/XRevan86">
							<img class="ui avatar image poping up" src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332" data-content="XRevan86" data-position="top center" data-variation="small inverted">
						</a>
					
				</div>
			</div>
		</div>
	</div>
</div>

<div class="hide" id="edit-content-form">
	<div class="ui comment form">
		<div class="ui top attached tabular menu">
			<a class="active write item">Write</a>
			<a class="preview item" data-url="/api/v1/markdown" data-context="/diogo/gnu-social">Preview</a>
		</div>
		<div class="ui bottom attached active write tab segment">
			<textarea tabindex="1" id="content" name="content"></textarea>
		</div>
		<div class="ui bottom attached tab preview segment markdown">
			Loading...
		</div>
		<div class="text right edit buttons">
			<div class="ui basic blue cancel button" tabindex="3">Cancel</div>
			<div class="ui green save button" tabindex="2">Save</div>
		</div>
	</div>
</div>

<div class="hide" id="no-content">
	<span class="no-content">There is no content yet.</span>
</div>

			</div>
		
	</div>
</div>

	</div>
	<footer>
		<div class="ui container">
			<div class="ui left">



				<a href="/tos">Terms of Service</a>
				&bull;
				<a href="/about">About us</a>
				&bull;
				<a href="/outages">Outages</a>
				&bull;
				<a href="/hp/gogs/issues">Report a problem</a>
				&bull;
				<a href="/assets/librejs/librejs.html" data-jslicense="1">Javascript licenses</a>
				&bull;
				<a href="/fingerprints">SSH Fingerprints</a>



			</div>
			<div class="ui right links">
				
				<div class="ui language bottom floating slide up dropdown link item">
					<i class="world icon"></i>
					<div class="text">English</div>
					<div class="menu">
						
							<a class="item active selected" href="#">English</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=zh-CN">简体中文</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=zh-HK">繁體中文（香港）</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=zh-TW">繁體中文（臺灣）</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=de-DE">Deutsch</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=fr-FR">français</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=nl-NL">Nederlands</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=lv-LV">latviešu</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=ru-RU">русский</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=ja-JP">日本語</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=es-ES">español</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=pt-BR">português do Brasil</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=pl-PL">polski</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=bg-BG">български</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=it-IT">italiano</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=fi-FI">suomi</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=tr-TR">Türkçe</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=cs-CZ">čeština</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=sr-SP">српски</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=sv-SE">svenska</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=ko-KR">한국어</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=gl-ES">galego</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=uk-UA">українська</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=en-GB">English (United Kingdom)</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=hu-HU">Magyar</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=sk-SK">Slovenčina</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=id-ID">Indonesian</a>
						
							<a class="item " href="/diogo/gnu-social/issues/205?lang=fa-IR">Persian</a>
						
					</div>
				</div>



				
			</div>
		</div>
	</footer>
</body>



	<link rel="stylesheet" href="/plugins/highlight-9.6.0/github.css">
	<script src="/plugins/highlight-9.6.0/highlight.pack.js"></script>




	<link rel="stylesheet" href="/plugins/dropzone-4.2.0/dropzone.css">
	<script src="/plugins/dropzone-4.2.0/dropzone.js"></script>

<script src="/js/libs/emojify-1.1.0.min.js"></script>
<script src="/js/libs/clipboard-1.5.9.min.js"></script>
	
</html>

